{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "cdf = pd.read_csv(\"characters-wikidata-lang-works-gender.csv\",names=[\"name\",\"wikiid\",\"n-lang\",\"n-works\",\"gender\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>wikiid</th>\n",
       "      <th>n-lang</th>\n",
       "      <th>n-works</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sauron</td>\n",
       "      <td>http://www.wikidata.org/entity/Q2281</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sherlock Holmes</td>\n",
       "      <td>http://www.wikidata.org/entity/Q4653</td>\n",
       "      <td>100</td>\n",
       "      <td>59</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Pippi Langstrumpf</td>\n",
       "      <td>http://www.wikidata.org/entity/Q6668</td>\n",
       "      <td>53</td>\n",
       "      <td>12</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Asajj Ventress</td>\n",
       "      <td>http://www.wikidata.org/entity/Q14417</td>\n",
       "      <td>17</td>\n",
       "      <td>2</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ijon Tichy</td>\n",
       "      <td>http://www.wikidata.org/entity/Q15160</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5872</th>\n",
       "      <td>A. Square</td>\n",
       "      <td>http://www.wikidata.org/entity/Q100275795</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5873</th>\n",
       "      <td>Q100294163</td>\n",
       "      <td>http://www.wikidata.org/entity/Q100294163</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5874</th>\n",
       "      <td>Anki Jönsson</td>\n",
       "      <td>http://www.wikidata.org/entity/Q100312346</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5875</th>\n",
       "      <td>Captain Ramón</td>\n",
       "      <td>http://www.wikidata.org/entity/Q100324137</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5876</th>\n",
       "      <td>Q100429960</td>\n",
       "      <td>http://www.wikidata.org/entity/Q100429960</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5877 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   name                                     wikiid  n-lang  \\\n",
       "0                Sauron       http://www.wikidata.org/entity/Q2281      50   \n",
       "1       Sherlock Holmes       http://www.wikidata.org/entity/Q4653     100   \n",
       "2     Pippi Langstrumpf       http://www.wikidata.org/entity/Q6668      53   \n",
       "3        Asajj Ventress      http://www.wikidata.org/entity/Q14417      17   \n",
       "4            Ijon Tichy      http://www.wikidata.org/entity/Q15160       8   \n",
       "...                 ...                                        ...     ...   \n",
       "5872          A. Square  http://www.wikidata.org/entity/Q100275795       0   \n",
       "5873         Q100294163  http://www.wikidata.org/entity/Q100294163       0   \n",
       "5874       Anki Jönsson  http://www.wikidata.org/entity/Q100312346       0   \n",
       "5875      Captain Ramón  http://www.wikidata.org/entity/Q100324137       1   \n",
       "5876         Q100429960  http://www.wikidata.org/entity/Q100429960       2   \n",
       "\n",
       "      n-works  gender  \n",
       "0           2    male  \n",
       "1          59    male  \n",
       "2          12  female  \n",
       "3           2  female  \n",
       "4           3    male  \n",
       "...       ...     ...  \n",
       "5872        0    male  \n",
       "5873        1    none  \n",
       "5874        0  female  \n",
       "5875        1    male  \n",
       "5876        0  female  \n",
       "\n",
       "[5877 rows x 5 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>wikiid</th>\n",
       "      <th>n-lang</th>\n",
       "      <th>n-works</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sauron</td>\n",
       "      <td>http://www.wikidata.org/entity/Q2281</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sherlock Holmes</td>\n",
       "      <td>http://www.wikidata.org/entity/Q4653</td>\n",
       "      <td>100</td>\n",
       "      <td>59</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Pippi Langstrumpf</td>\n",
       "      <td>http://www.wikidata.org/entity/Q6668</td>\n",
       "      <td>53</td>\n",
       "      <td>12</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Asajj Ventress</td>\n",
       "      <td>http://www.wikidata.org/entity/Q14417</td>\n",
       "      <td>17</td>\n",
       "      <td>2</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ijon Tichy</td>\n",
       "      <td>http://www.wikidata.org/entity/Q15160</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                name                                 wikiid  n-lang  n-works  \\\n",
       "0             Sauron   http://www.wikidata.org/entity/Q2281      50        2   \n",
       "1    Sherlock Holmes   http://www.wikidata.org/entity/Q4653     100       59   \n",
       "2  Pippi Langstrumpf   http://www.wikidata.org/entity/Q6668      53       12   \n",
       "3     Asajj Ventress  http://www.wikidata.org/entity/Q14417      17        2   \n",
       "4         Ijon Tichy  http://www.wikidata.org/entity/Q15160       8        3   \n",
       "\n",
       "   gender  \n",
       "0    male  \n",
       "1    male  \n",
       "2  female  \n",
       "3  female  \n",
       "4    male  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>wikiid</th>\n",
       "      <th>n-lang</th>\n",
       "      <th>n-works</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sherlock Holmes</td>\n",
       "      <td>http://www.wikidata.org/entity/Q4653</td>\n",
       "      <td>100</td>\n",
       "      <td>59</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Weihnachtsmann</td>\n",
       "      <td>http://www.wikidata.org/entity/Q315796</td>\n",
       "      <td>95</td>\n",
       "      <td>10</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479</th>\n",
       "      <td>Harry Potter</td>\n",
       "      <td>http://www.wikidata.org/entity/Q3244512</td>\n",
       "      <td>82</td>\n",
       "      <td>18</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Gilgamesch</td>\n",
       "      <td>http://www.wikidata.org/entity/Q159709</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Ron Weasley</td>\n",
       "      <td>http://www.wikidata.org/entity/Q173998</td>\n",
       "      <td>74</td>\n",
       "      <td>14</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Pu der Bär</td>\n",
       "      <td>http://www.wikidata.org/entity/Q188574</td>\n",
       "      <td>74</td>\n",
       "      <td>5</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Hermine Granger</td>\n",
       "      <td>http://www.wikidata.org/entity/Q174009</td>\n",
       "      <td>73</td>\n",
       "      <td>17</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Tarzan</td>\n",
       "      <td>http://www.wikidata.org/entity/Q170241</td>\n",
       "      <td>73</td>\n",
       "      <td>15</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Lord Voldemort</td>\n",
       "      <td>http://www.wikidata.org/entity/Q176132</td>\n",
       "      <td>70</td>\n",
       "      <td>15</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Pandora</td>\n",
       "      <td>http://www.wikidata.org/entity/Q131346</td>\n",
       "      <td>69</td>\n",
       "      <td>0</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>Albus Dumbledore</td>\n",
       "      <td>http://www.wikidata.org/entity/Q712548</td>\n",
       "      <td>68</td>\n",
       "      <td>15</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Arjuna</td>\n",
       "      <td>http://www.wikidata.org/entity/Q185790</td>\n",
       "      <td>65</td>\n",
       "      <td>4</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Severus Snape</td>\n",
       "      <td>http://www.wikidata.org/entity/Q176772</td>\n",
       "      <td>63</td>\n",
       "      <td>12</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Peter Pan</td>\n",
       "      <td>http://www.wikidata.org/entity/Q107190</td>\n",
       "      <td>62</td>\n",
       "      <td>7</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Rubeus Hagrid</td>\n",
       "      <td>http://www.wikidata.org/entity/Q177439</td>\n",
       "      <td>60</td>\n",
       "      <td>11</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Wolverine</td>\n",
       "      <td>http://www.wikidata.org/entity/Q186422</td>\n",
       "      <td>58</td>\n",
       "      <td>9</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Gandalf</td>\n",
       "      <td>http://www.wikidata.org/entity/Q177499</td>\n",
       "      <td>57</td>\n",
       "      <td>5</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Draco Malfoy</td>\n",
       "      <td>http://www.wikidata.org/entity/Q179641</td>\n",
       "      <td>56</td>\n",
       "      <td>11</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2836</th>\n",
       "      <td>Pinocchio</td>\n",
       "      <td>http://www.wikidata.org/entity/Q6502703</td>\n",
       "      <td>56</td>\n",
       "      <td>5</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Dr. Watson</td>\n",
       "      <td>http://www.wikidata.org/entity/Q187349</td>\n",
       "      <td>56</td>\n",
       "      <td>44</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Hercule Poirot</td>\n",
       "      <td>http://www.wikidata.org/entity/Q170534</td>\n",
       "      <td>54</td>\n",
       "      <td>95</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Pippi Langstrumpf</td>\n",
       "      <td>http://www.wikidata.org/entity/Q6668</td>\n",
       "      <td>53</td>\n",
       "      <td>12</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Bilbo Beutlin</td>\n",
       "      <td>http://www.wikidata.org/entity/Q185737</td>\n",
       "      <td>51</td>\n",
       "      <td>5</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sauron</td>\n",
       "      <td>http://www.wikidata.org/entity/Q2281</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1491</th>\n",
       "      <td>Graf Dracula</td>\n",
       "      <td>http://www.wikidata.org/entity/Q3266236</td>\n",
       "      <td>49</td>\n",
       "      <td>22</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Scheherazade</td>\n",
       "      <td>http://www.wikidata.org/entity/Q216445</td>\n",
       "      <td>47</td>\n",
       "      <td>2</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Osterhase</td>\n",
       "      <td>http://www.wikidata.org/entity/Q108636</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Miss Marple</td>\n",
       "      <td>http://www.wikidata.org/entity/Q193531</td>\n",
       "      <td>45</td>\n",
       "      <td>33</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Golem</td>\n",
       "      <td>http://www.wikidata.org/entity/Q215085</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Sindbad</td>\n",
       "      <td>http://www.wikidata.org/entity/Q122018</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Conan der Cimmerier</td>\n",
       "      <td>http://www.wikidata.org/entity/Q189169</td>\n",
       "      <td>45</td>\n",
       "      <td>37</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Ginny Weasley</td>\n",
       "      <td>http://www.wikidata.org/entity/Q187923</td>\n",
       "      <td>44</td>\n",
       "      <td>10</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>King Kong</td>\n",
       "      <td>http://www.wikidata.org/entity/Q216810</td>\n",
       "      <td>43</td>\n",
       "      <td>2</td>\n",
       "      <td>male organism</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>Sirius Black</td>\n",
       "      <td>http://www.wikidata.org/entity/Q713701</td>\n",
       "      <td>42</td>\n",
       "      <td>6</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Robert Langdon</td>\n",
       "      <td>http://www.wikidata.org/entity/Q210548</td>\n",
       "      <td>41</td>\n",
       "      <td>8</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Hannibal Lecter</td>\n",
       "      <td>http://www.wikidata.org/entity/Q211013</td>\n",
       "      <td>41</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Lancelot</td>\n",
       "      <td>http://www.wikidata.org/entity/Q215681</td>\n",
       "      <td>41</td>\n",
       "      <td>6</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Till Eulenspiegel</td>\n",
       "      <td>http://www.wikidata.org/entity/Q164083</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>James Moriarty</td>\n",
       "      <td>http://www.wikidata.org/entity/Q283111</td>\n",
       "      <td>39</td>\n",
       "      <td>10</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Zorro</td>\n",
       "      <td>http://www.wikidata.org/entity/Q226822</td>\n",
       "      <td>39</td>\n",
       "      <td>4</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Smaug</td>\n",
       "      <td>http://www.wikidata.org/entity/Q46302</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Neville Longbottom</td>\n",
       "      <td>http://www.wikidata.org/entity/Q190366</td>\n",
       "      <td>39</td>\n",
       "      <td>8</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>Doctor Strange</td>\n",
       "      <td>http://www.wikidata.org/entity/Q907767</td>\n",
       "      <td>38</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Minerva McGonagall</td>\n",
       "      <td>http://www.wikidata.org/entity/Q192179</td>\n",
       "      <td>38</td>\n",
       "      <td>9</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Spock</td>\n",
       "      <td>http://www.wikidata.org/entity/Q16341</td>\n",
       "      <td>37</td>\n",
       "      <td>428</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>Großer Bruder</td>\n",
       "      <td>http://www.wikidata.org/entity/Q751417</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Arsène Lupin</td>\n",
       "      <td>http://www.wikidata.org/entity/Q461606</td>\n",
       "      <td>37</td>\n",
       "      <td>48</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Elrond</td>\n",
       "      <td>http://www.wikidata.org/entity/Q208426</td>\n",
       "      <td>36</td>\n",
       "      <td>4</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>Vito Corleone</td>\n",
       "      <td>http://www.wikidata.org/entity/Q745077</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656</th>\n",
       "      <td>Mycroft Holmes</td>\n",
       "      <td>http://www.wikidata.org/entity/Q1616457</td>\n",
       "      <td>35</td>\n",
       "      <td>6</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     name                                   wikiid  n-lang  \\\n",
       "1         Sherlock Holmes     http://www.wikidata.org/entity/Q4653     100   \n",
       "109        Weihnachtsmann   http://www.wikidata.org/entity/Q315796      95   \n",
       "1479         Harry Potter  http://www.wikidata.org/entity/Q3244512      82   \n",
       "49             Gilgamesch   http://www.wikidata.org/entity/Q159709      80   \n",
       "57            Ron Weasley   http://www.wikidata.org/entity/Q173998      74   \n",
       "70             Pu der Bär   http://www.wikidata.org/entity/Q188574      74   \n",
       "58        Hermine Granger   http://www.wikidata.org/entity/Q174009      73   \n",
       "55                 Tarzan   http://www.wikidata.org/entity/Q170241      73   \n",
       "59         Lord Voldemort   http://www.wikidata.org/entity/Q176132      70   \n",
       "41                Pandora   http://www.wikidata.org/entity/Q131346      69   \n",
       "228      Albus Dumbledore   http://www.wikidata.org/entity/Q712548      68   \n",
       "66                 Arjuna   http://www.wikidata.org/entity/Q185790      65   \n",
       "60          Severus Snape   http://www.wikidata.org/entity/Q176772      63   \n",
       "33              Peter Pan   http://www.wikidata.org/entity/Q107190      62   \n",
       "61          Rubeus Hagrid   http://www.wikidata.org/entity/Q177439      60   \n",
       "67              Wolverine   http://www.wikidata.org/entity/Q186422      58   \n",
       "62                Gandalf   http://www.wikidata.org/entity/Q177499      57   \n",
       "64           Draco Malfoy   http://www.wikidata.org/entity/Q179641      56   \n",
       "2836            Pinocchio  http://www.wikidata.org/entity/Q6502703      56   \n",
       "68             Dr. Watson   http://www.wikidata.org/entity/Q187349      56   \n",
       "56         Hercule Poirot   http://www.wikidata.org/entity/Q170534      54   \n",
       "2       Pippi Langstrumpf     http://www.wikidata.org/entity/Q6668      53   \n",
       "65          Bilbo Beutlin   http://www.wikidata.org/entity/Q185737      51   \n",
       "0                  Sauron     http://www.wikidata.org/entity/Q2281      50   \n",
       "1491         Graf Dracula  http://www.wikidata.org/entity/Q3266236      49   \n",
       "84           Scheherazade   http://www.wikidata.org/entity/Q216445      47   \n",
       "34              Osterhase   http://www.wikidata.org/entity/Q108636      46   \n",
       "75            Miss Marple   http://www.wikidata.org/entity/Q193531      45   \n",
       "82                  Golem   http://www.wikidata.org/entity/Q215085      45   \n",
       "38                Sindbad   http://www.wikidata.org/entity/Q122018      45   \n",
       "71    Conan der Cimmerier   http://www.wikidata.org/entity/Q189169      45   \n",
       "69          Ginny Weasley   http://www.wikidata.org/entity/Q187923      44   \n",
       "85              King Kong   http://www.wikidata.org/entity/Q216810      43   \n",
       "230          Sirius Black   http://www.wikidata.org/entity/Q713701      42   \n",
       "80         Robert Langdon   http://www.wikidata.org/entity/Q210548      41   \n",
       "81        Hannibal Lecter   http://www.wikidata.org/entity/Q211013      41   \n",
       "83               Lancelot   http://www.wikidata.org/entity/Q215681      41   \n",
       "54      Till Eulenspiegel   http://www.wikidata.org/entity/Q164083      40   \n",
       "104        James Moriarty   http://www.wikidata.org/entity/Q283111      39   \n",
       "90                  Zorro   http://www.wikidata.org/entity/Q226822      39   \n",
       "19                  Smaug    http://www.wikidata.org/entity/Q46302      39   \n",
       "73     Neville Longbottom   http://www.wikidata.org/entity/Q190366      39   \n",
       "385        Doctor Strange   http://www.wikidata.org/entity/Q907767      38   \n",
       "74     Minerva McGonagall   http://www.wikidata.org/entity/Q192179      38   \n",
       "8                   Spock    http://www.wikidata.org/entity/Q16341      37   \n",
       "251         Großer Bruder   http://www.wikidata.org/entity/Q751417      37   \n",
       "137          Arsène Lupin   http://www.wikidata.org/entity/Q461606      37   \n",
       "78                 Elrond   http://www.wikidata.org/entity/Q208426      36   \n",
       "247         Vito Corleone   http://www.wikidata.org/entity/Q745077      36   \n",
       "656        Mycroft Holmes  http://www.wikidata.org/entity/Q1616457      35   \n",
       "\n",
       "      n-works         gender  \n",
       "1          59           male  \n",
       "109        10           male  \n",
       "1479       18           male  \n",
       "49          2           male  \n",
       "57         14           male  \n",
       "70          5           male  \n",
       "58         17         female  \n",
       "55         15           male  \n",
       "59         15           male  \n",
       "41          0         female  \n",
       "228        15           male  \n",
       "66          4           male  \n",
       "60         12           male  \n",
       "33          7           male  \n",
       "61         11           male  \n",
       "67          9           male  \n",
       "62          5           male  \n",
       "64         11           male  \n",
       "2836        5           male  \n",
       "68         44           male  \n",
       "56         95           male  \n",
       "2          12         female  \n",
       "65          5           male  \n",
       "0           2           male  \n",
       "1491       22           male  \n",
       "84          2         female  \n",
       "34          0           none  \n",
       "75         33         female  \n",
       "82          0           none  \n",
       "38          2           male  \n",
       "71         37           male  \n",
       "69         10         female  \n",
       "85          2  male organism  \n",
       "230         6           male  \n",
       "80          8           male  \n",
       "81          2           male  \n",
       "83          6           male  \n",
       "54          2           male  \n",
       "104        10           male  \n",
       "90          4           male  \n",
       "19          0           male  \n",
       "73          8           male  \n",
       "385         2           male  \n",
       "74          9         female  \n",
       "8         428           male  \n",
       "251         1           none  \n",
       "137        48           male  \n",
       "78          4           male  \n",
       "247         1           male  \n",
       "656         6           male  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cdf.sort_values('n-lang',ascending=False).head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>wikiid</th>\n",
       "      <th>n-lang</th>\n",
       "      <th>n-works</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sherlock Holmes</td>\n",
       "      <td>http://www.wikidata.org/entity/Q4653</td>\n",
       "      <td>100</td>\n",
       "      <td>59</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Weihnachtsmann</td>\n",
       "      <td>http://www.wikidata.org/entity/Q315796</td>\n",
       "      <td>95</td>\n",
       "      <td>10</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479</th>\n",
       "      <td>Harry Potter</td>\n",
       "      <td>http://www.wikidata.org/entity/Q3244512</td>\n",
       "      <td>82</td>\n",
       "      <td>18</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Gilgamesch</td>\n",
       "      <td>http://www.wikidata.org/entity/Q159709</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Ron Weasley</td>\n",
       "      <td>http://www.wikidata.org/entity/Q173998</td>\n",
       "      <td>74</td>\n",
       "      <td>14</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Pu der Bär</td>\n",
       "      <td>http://www.wikidata.org/entity/Q188574</td>\n",
       "      <td>74</td>\n",
       "      <td>5</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Hermine Granger</td>\n",
       "      <td>http://www.wikidata.org/entity/Q174009</td>\n",
       "      <td>73</td>\n",
       "      <td>17</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Tarzan</td>\n",
       "      <td>http://www.wikidata.org/entity/Q170241</td>\n",
       "      <td>73</td>\n",
       "      <td>15</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Lord Voldemort</td>\n",
       "      <td>http://www.wikidata.org/entity/Q176132</td>\n",
       "      <td>70</td>\n",
       "      <td>15</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Pandora</td>\n",
       "      <td>http://www.wikidata.org/entity/Q131346</td>\n",
       "      <td>69</td>\n",
       "      <td>0</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>Albus Dumbledore</td>\n",
       "      <td>http://www.wikidata.org/entity/Q712548</td>\n",
       "      <td>68</td>\n",
       "      <td>15</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Arjuna</td>\n",
       "      <td>http://www.wikidata.org/entity/Q185790</td>\n",
       "      <td>65</td>\n",
       "      <td>4</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Severus Snape</td>\n",
       "      <td>http://www.wikidata.org/entity/Q176772</td>\n",
       "      <td>63</td>\n",
       "      <td>12</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Peter Pan</td>\n",
       "      <td>http://www.wikidata.org/entity/Q107190</td>\n",
       "      <td>62</td>\n",
       "      <td>7</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Rubeus Hagrid</td>\n",
       "      <td>http://www.wikidata.org/entity/Q177439</td>\n",
       "      <td>60</td>\n",
       "      <td>11</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Wolverine</td>\n",
       "      <td>http://www.wikidata.org/entity/Q186422</td>\n",
       "      <td>58</td>\n",
       "      <td>9</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Gandalf</td>\n",
       "      <td>http://www.wikidata.org/entity/Q177499</td>\n",
       "      <td>57</td>\n",
       "      <td>5</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Draco Malfoy</td>\n",
       "      <td>http://www.wikidata.org/entity/Q179641</td>\n",
       "      <td>56</td>\n",
       "      <td>11</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2836</th>\n",
       "      <td>Pinocchio</td>\n",
       "      <td>http://www.wikidata.org/entity/Q6502703</td>\n",
       "      <td>56</td>\n",
       "      <td>5</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Dr. Watson</td>\n",
       "      <td>http://www.wikidata.org/entity/Q187349</td>\n",
       "      <td>56</td>\n",
       "      <td>44</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Hercule Poirot</td>\n",
       "      <td>http://www.wikidata.org/entity/Q170534</td>\n",
       "      <td>54</td>\n",
       "      <td>95</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Pippi Langstrumpf</td>\n",
       "      <td>http://www.wikidata.org/entity/Q6668</td>\n",
       "      <td>53</td>\n",
       "      <td>12</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Bilbo Beutlin</td>\n",
       "      <td>http://www.wikidata.org/entity/Q185737</td>\n",
       "      <td>51</td>\n",
       "      <td>5</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sauron</td>\n",
       "      <td>http://www.wikidata.org/entity/Q2281</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1491</th>\n",
       "      <td>Graf Dracula</td>\n",
       "      <td>http://www.wikidata.org/entity/Q3266236</td>\n",
       "      <td>49</td>\n",
       "      <td>22</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Scheherazade</td>\n",
       "      <td>http://www.wikidata.org/entity/Q216445</td>\n",
       "      <td>47</td>\n",
       "      <td>2</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Osterhase</td>\n",
       "      <td>http://www.wikidata.org/entity/Q108636</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Miss Marple</td>\n",
       "      <td>http://www.wikidata.org/entity/Q193531</td>\n",
       "      <td>45</td>\n",
       "      <td>33</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Golem</td>\n",
       "      <td>http://www.wikidata.org/entity/Q215085</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Sindbad</td>\n",
       "      <td>http://www.wikidata.org/entity/Q122018</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Conan der Cimmerier</td>\n",
       "      <td>http://www.wikidata.org/entity/Q189169</td>\n",
       "      <td>45</td>\n",
       "      <td>37</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Ginny Weasley</td>\n",
       "      <td>http://www.wikidata.org/entity/Q187923</td>\n",
       "      <td>44</td>\n",
       "      <td>10</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>King Kong</td>\n",
       "      <td>http://www.wikidata.org/entity/Q216810</td>\n",
       "      <td>43</td>\n",
       "      <td>2</td>\n",
       "      <td>male organism</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>Sirius Black</td>\n",
       "      <td>http://www.wikidata.org/entity/Q713701</td>\n",
       "      <td>42</td>\n",
       "      <td>6</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Robert Langdon</td>\n",
       "      <td>http://www.wikidata.org/entity/Q210548</td>\n",
       "      <td>41</td>\n",
       "      <td>8</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Hannibal Lecter</td>\n",
       "      <td>http://www.wikidata.org/entity/Q211013</td>\n",
       "      <td>41</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Lancelot</td>\n",
       "      <td>http://www.wikidata.org/entity/Q215681</td>\n",
       "      <td>41</td>\n",
       "      <td>6</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Till Eulenspiegel</td>\n",
       "      <td>http://www.wikidata.org/entity/Q164083</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>James Moriarty</td>\n",
       "      <td>http://www.wikidata.org/entity/Q283111</td>\n",
       "      <td>39</td>\n",
       "      <td>10</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Zorro</td>\n",
       "      <td>http://www.wikidata.org/entity/Q226822</td>\n",
       "      <td>39</td>\n",
       "      <td>4</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Smaug</td>\n",
       "      <td>http://www.wikidata.org/entity/Q46302</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Neville Longbottom</td>\n",
       "      <td>http://www.wikidata.org/entity/Q190366</td>\n",
       "      <td>39</td>\n",
       "      <td>8</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>Doctor Strange</td>\n",
       "      <td>http://www.wikidata.org/entity/Q907767</td>\n",
       "      <td>38</td>\n",
       "      <td>2</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Minerva McGonagall</td>\n",
       "      <td>http://www.wikidata.org/entity/Q192179</td>\n",
       "      <td>38</td>\n",
       "      <td>9</td>\n",
       "      <td>female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Spock</td>\n",
       "      <td>http://www.wikidata.org/entity/Q16341</td>\n",
       "      <td>37</td>\n",
       "      <td>428</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>Großer Bruder</td>\n",
       "      <td>http://www.wikidata.org/entity/Q751417</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Arsène Lupin</td>\n",
       "      <td>http://www.wikidata.org/entity/Q461606</td>\n",
       "      <td>37</td>\n",
       "      <td>48</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Elrond</td>\n",
       "      <td>http://www.wikidata.org/entity/Q208426</td>\n",
       "      <td>36</td>\n",
       "      <td>4</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>Vito Corleone</td>\n",
       "      <td>http://www.wikidata.org/entity/Q745077</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656</th>\n",
       "      <td>Mycroft Holmes</td>\n",
       "      <td>http://www.wikidata.org/entity/Q1616457</td>\n",
       "      <td>35</td>\n",
       "      <td>6</td>\n",
       "      <td>male</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     name                                   wikiid  n-lang  \\\n",
       "1         Sherlock Holmes     http://www.wikidata.org/entity/Q4653     100   \n",
       "109        Weihnachtsmann   http://www.wikidata.org/entity/Q315796      95   \n",
       "1479         Harry Potter  http://www.wikidata.org/entity/Q3244512      82   \n",
       "49             Gilgamesch   http://www.wikidata.org/entity/Q159709      80   \n",
       "57            Ron Weasley   http://www.wikidata.org/entity/Q173998      74   \n",
       "70             Pu der Bär   http://www.wikidata.org/entity/Q188574      74   \n",
       "58        Hermine Granger   http://www.wikidata.org/entity/Q174009      73   \n",
       "55                 Tarzan   http://www.wikidata.org/entity/Q170241      73   \n",
       "59         Lord Voldemort   http://www.wikidata.org/entity/Q176132      70   \n",
       "41                Pandora   http://www.wikidata.org/entity/Q131346      69   \n",
       "228      Albus Dumbledore   http://www.wikidata.org/entity/Q712548      68   \n",
       "66                 Arjuna   http://www.wikidata.org/entity/Q185790      65   \n",
       "60          Severus Snape   http://www.wikidata.org/entity/Q176772      63   \n",
       "33              Peter Pan   http://www.wikidata.org/entity/Q107190      62   \n",
       "61          Rubeus Hagrid   http://www.wikidata.org/entity/Q177439      60   \n",
       "67              Wolverine   http://www.wikidata.org/entity/Q186422      58   \n",
       "62                Gandalf   http://www.wikidata.org/entity/Q177499      57   \n",
       "64           Draco Malfoy   http://www.wikidata.org/entity/Q179641      56   \n",
       "2836            Pinocchio  http://www.wikidata.org/entity/Q6502703      56   \n",
       "68             Dr. Watson   http://www.wikidata.org/entity/Q187349      56   \n",
       "56         Hercule Poirot   http://www.wikidata.org/entity/Q170534      54   \n",
       "2       Pippi Langstrumpf     http://www.wikidata.org/entity/Q6668      53   \n",
       "65          Bilbo Beutlin   http://www.wikidata.org/entity/Q185737      51   \n",
       "0                  Sauron     http://www.wikidata.org/entity/Q2281      50   \n",
       "1491         Graf Dracula  http://www.wikidata.org/entity/Q3266236      49   \n",
       "84           Scheherazade   http://www.wikidata.org/entity/Q216445      47   \n",
       "34              Osterhase   http://www.wikidata.org/entity/Q108636      46   \n",
       "75            Miss Marple   http://www.wikidata.org/entity/Q193531      45   \n",
       "82                  Golem   http://www.wikidata.org/entity/Q215085      45   \n",
       "38                Sindbad   http://www.wikidata.org/entity/Q122018      45   \n",
       "71    Conan der Cimmerier   http://www.wikidata.org/entity/Q189169      45   \n",
       "69          Ginny Weasley   http://www.wikidata.org/entity/Q187923      44   \n",
       "85              King Kong   http://www.wikidata.org/entity/Q216810      43   \n",
       "230          Sirius Black   http://www.wikidata.org/entity/Q713701      42   \n",
       "80         Robert Langdon   http://www.wikidata.org/entity/Q210548      41   \n",
       "81        Hannibal Lecter   http://www.wikidata.org/entity/Q211013      41   \n",
       "83               Lancelot   http://www.wikidata.org/entity/Q215681      41   \n",
       "54      Till Eulenspiegel   http://www.wikidata.org/entity/Q164083      40   \n",
       "104        James Moriarty   http://www.wikidata.org/entity/Q283111      39   \n",
       "90                  Zorro   http://www.wikidata.org/entity/Q226822      39   \n",
       "19                  Smaug    http://www.wikidata.org/entity/Q46302      39   \n",
       "73     Neville Longbottom   http://www.wikidata.org/entity/Q190366      39   \n",
       "385        Doctor Strange   http://www.wikidata.org/entity/Q907767      38   \n",
       "74     Minerva McGonagall   http://www.wikidata.org/entity/Q192179      38   \n",
       "8                   Spock    http://www.wikidata.org/entity/Q16341      37   \n",
       "251         Großer Bruder   http://www.wikidata.org/entity/Q751417      37   \n",
       "137          Arsène Lupin   http://www.wikidata.org/entity/Q461606      37   \n",
       "78                 Elrond   http://www.wikidata.org/entity/Q208426      36   \n",
       "247         Vito Corleone   http://www.wikidata.org/entity/Q745077      36   \n",
       "656        Mycroft Holmes  http://www.wikidata.org/entity/Q1616457      35   \n",
       "\n",
       "      n-works         gender  \n",
       "1          59           male  \n",
       "109        10           male  \n",
       "1479       18           male  \n",
       "49          2           male  \n",
       "57         14           male  \n",
       "70          5           male  \n",
       "58         17         female  \n",
       "55         15           male  \n",
       "59         15           male  \n",
       "41          0         female  \n",
       "228        15           male  \n",
       "66          4           male  \n",
       "60         12           male  \n",
       "33          7           male  \n",
       "61         11           male  \n",
       "67          9           male  \n",
       "62          5           male  \n",
       "64         11           male  \n",
       "2836        5           male  \n",
       "68         44           male  \n",
       "56         95           male  \n",
       "2          12         female  \n",
       "65          5           male  \n",
       "0           2           male  \n",
       "1491       22           male  \n",
       "84          2         female  \n",
       "34          0           none  \n",
       "75         33         female  \n",
       "82          0           none  \n",
       "38          2           male  \n",
       "71         37           male  \n",
       "69         10         female  \n",
       "85          2  male organism  \n",
       "230         6           male  \n",
       "80          8           male  \n",
       "81          2           male  \n",
       "83          6           male  \n",
       "54          2           male  \n",
       "104        10           male  \n",
       "90          4           male  \n",
       "19          0           male  \n",
       "73          8           male  \n",
       "385         2           male  \n",
       "74          9         female  \n",
       "8         428           male  \n",
       "251         1           none  \n",
       "137        48           male  \n",
       "78          4           male  \n",
       "247         1           male  \n",
       "656         6           male  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cdf.sort_values('n-lang',ascending=False).head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "cdf.sort_values('n-lang',ascending=False).to_csv(\"characters_sorted_all.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
